[dbo].[Basket_Function]

Property	Value
Created	3:11:47 PM Friday, January 07, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Basket_Function: ID\IP_ADDRESS\ST_ID\PRODUCT_CODE$	ID	varchar(10)	10	('')
$Cluster Primary Key PK_Basket_Function: ID\IP_ADDRESS\ST_ID\PRODUCT_CODE$	IP_ADDRESS	varchar(30)	30	('')
$Cluster Primary Key PK_Basket_Function: ID\IP_ADDRESS\ST_ID\PRODUCT_CODE$	ST_ID	varchar(10)	10	('')
	PRODUCT_MINOR	varchar(15)	15	('')
	PRODUCT_MAJOR	varchar(15)	15	('')
$Cluster Primary Key PK_Basket_Function: ID\IP_ADDRESS\ST_ID\PRODUCT_CODE$	PRODUCT_CODE	varchar(31)	31	('')
	TITLE	varchar(60)	60	('')
	BEGIN_DATE	datetime	8
	END_DATE	datetime	8
	BEGIN_TIME	datetime	8
	END_TIME	datetime	8
	EXTENDED_AMOUNT	money	8	((0))
	INCOME_ACCOUNT	varchar(50)	50	('')
	DEFERRED_INCOME_ACCOUNT	varchar(50)	50	('')
	QUANTITY_ORDERED	float	8	((0))
	ORG_CODE	varchar(5)	5	('')
	IS_FR_ITEM	bit	1	((0))
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_Basket_Function: ID\IP_ADDRESS\ST_ID\PRODUCT_CODE$	PK_Basket_Function	ID, IP_ADDRESS, ST_ID, PRODUCT_CODE

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Basket_Function]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_ID] DEFAULT (''),
[IP_ADDRESS] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_IP_ADDRESS] DEFAULT (''),
[ST_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_ST_ID] DEFAULT (''),
[PRODUCT_MINOR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_PRODUCT_MINOR] DEFAULT (''),
[PRODUCT_MAJOR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_PRODUCT_MAJOR] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_PRODUCT_CODE] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_TITLE] DEFAULT (''),
[BEGIN_DATE] [datetime] NULL,
[END_DATE] [datetime] NULL,
[BEGIN_TIME] [datetime] NULL,
[END_TIME] [datetime] NULL,
[EXTENDED_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Basket_Function_EXTENDED_AMOUNT] DEFAULT ((0)),
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_INCOME_ACCOUNT] DEFAULT (''),
[DEFERRED_INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_DEFERRED_INCOME_ACCOUNT] DEFAULT (''),
[QUANTITY_ORDERED] [float] NOT NULL CONSTRAINT [DF_Basket_Function_QUANTITY_ORDERED] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Basket_Function_ORG_CODE] DEFAULT (''),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Basket_Function_IS_FR_ITEM] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Basket_Function] ADD CONSTRAINT [PK_Basket_Function] PRIMARY KEY CLUSTERED ([ID], [IP_ADDRESS], [ST_ID], [PRODUCT_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Basket_Function] TO [IMIS]
GRANT SELECT ON  [dbo].[Basket_Function] TO [IMIS]
GRANT INSERT ON  [dbo].[Basket_Function] TO [IMIS]
GRANT DELETE ON  [dbo].[Basket_Function] TO [IMIS]
GRANT UPDATE ON  [dbo].[Basket_Function] TO [IMIS]
GO